Run, Practice, Share: Your Interactive SQL Playground

INSERT INTO

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) MySQL 9.3.0 SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

The INSERT INTO statement is used to insert new records in a table.

1
2
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

INSERT INTO - Popular snippets

SELECT SHOW WHERE NOT DROP TABLE CREATE TABLE AUTO_INCREMENT DEFAULT PRIMARY KEY INSERT INTO INSERT INTO last run: 2024-12-04 00:37:29
11
MariaDB 10 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY INSERT INTO SELECT WHERE FOREIGN KEY INSERT INTO last run: 2023-10-28 20:37:06
6
SELECT SHOW WHERE NOT DROP TABLE CREATE TABLE AUTO_INCREMENT DEFAULT PRIMARY KEY INSERT INTO INSERT INTO last run: 2024-11-28 07:25:38
4
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT INSERT INTO SELECT UPDATE WHERE last run: 2024-10-01 10:51:41
4
MariaDB 10 DROP TABLE CREATE TABLE NOT CONSTRAINT PRIMARY KEY INSERT INTO SELECT WHERE FOREIGN KEY INSERT INTO last run: 2023-10-28 20:32:39
4
PostgreSQL 15 CREATE TABLE NOT PRIMARY KEY INSERT INTO INSERT INTO CONSTRAINT SELECT JOIN ORDER BY last run: 2025-01-02 17:53:27
3
SELECT SHOW WHERE NOT DROP TABLE CREATE TABLE AUTO_INCREMENT DEFAULT PRIMARY KEY INSERT INTO INSERT INTO last run: 2024-11-29 08:05:57
3
SELECT SHOW WHERE NOT DROP TABLE CREATE TABLE AUTO_INCREMENT DEFAULT PRIMARY KEY INSERT INTO INSERT INTO last run: 2024-12-04 00:44:03
3
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT INSERT INTO SELECT UPDATE WHERE last run: 2024-10-01 11:13:42
3
MariaDB 10 DROP TABLE CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY CONSTRAINT INSERT INTO SELECT WHERE FOREIGN KEY INSERT INTO CREATE VIEW LEFT JOIN DROP PROCEDURE CREATE PROCEDURE DROP VIEW COUNT GROUP BY last run: 2023-10-27 10:37:16
3

INSERT INTO - New snippets

MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT added at: 2025-04-20 17:24:06
2
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT added at: 2025-04-20 17:23:29
1
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT added at: 2025-04-20 16:49:40
1
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT added at: 2025-04-20 16:49:22
1
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO SELECT added at: 2025-04-20 16:43:31
2
MySQL 8.0 DROP TABLE CREATE TABLE AUTO_INCREMENT PRIMARY KEY NOT DEFAULT CREATE TABLE FOREIGN KEY INSERT INTO UPDATE WHERE INSERT INTO added at: 2025-04-20 16:37:32
1
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT added at: 2025-04-16 01:12:41
1
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT added at: 2025-04-16 01:12:11
1
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT added at: 2025-04-16 01:11:54
1
MS SQL Server 2019 CREATE TABLE AND INSERT INTO SELECT added at: 2025-04-16 01:11:15
1

SQLize.online - Popular functions

SELECT

1534k

WHERE

843k

ORDER BY

690k

CREATE TABLE

487k

JOIN

485k

INSERT INTO

434k

GROUP BY

405k

AND

370k

340k

PRIMARY KEY

314k

NOT

313k

COUNT

289k

SHOW

266k

WITH

164k

FOREIGN KEY

152k

LEFT

143k

CONSTRAINT

131k

DROP TABLE

116k

AUTO_INCREMENT

114k

INNER JOIN

113k

LENGTH

109k

102k

SUM

101k

DEFAULT

89k

HAVING

84k

UPDATE

70k

60k

BETWEEN

56k

CONCAT

44k

DELETE

42k

CASE

37k

ALTER TABLE

36k

CREATE VIEW

36k

DROP VIEW

27k

REPLACE

27k

ROW_NUMBER

25k

MONTH

24k

CREATE PROCEDURE

23k

EXEC

20k

DROP PROCEDURE

19k

RIGHT

18k

DENSE_RANK

12k

ADD CONSTRAINT

12k

COALESCE

12k

LEAD

11k

LAG

10k

SUBSTRING

10k

CROSS JOIN

OUTER JOIN

CREATE OR REPLACE FUNCTION

CREATE FUNCTION

INSERT INTO

ADD COLUMN

TRUNCATE

DAYOFWEEK

UPPER

SUBSTR

LOWER

DROP COLUMN

DESCRIBE

TRIM

INSERT INTO

LEFT JOIN

CREATE OR REPLACE VIEW

IFNULL

CREATE OR REPLACE PROCEDURE

REVERSE

JSON_ARRAY

JSON_CONTAINS

LPAD

DROP CONSTRAINT

INSERT INTO

855

ORDER BY

758

NULLIF

719

JSON_AGG

642

UUID_GENERATE_V4

628

INNER JOIN

519

INSERT INTO

437

CREATE OR REPLACE TRIGGER

437

GROUP BY

419

ADD CONSTRAINT

410

RTRIM

405

DROP FUNCTION

360

DROP INDEX

275

RPAD

262

LTRIM

226

DROP TRIGGER

192

FOREIGN KEY

178

PRIMARY KEY

153

ROW_TO_JSON

138

CREATE TABLE

132

DROP SEQUENCE

DROP PROCEDURE

ADD COLUMN

INNER JOIN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

SQLize Online / PHPize Online / SQLtest Online

INSERT INTO - Popular snippets

INSERT INTO - New snippets

SQLize.online - Popular functions